package cn.jiyun.mapper;

import cn.jiyun.pojo.Role;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author Lenovo
* @description 针对表【role】的数据库操作Mapper
* @createDate 2024-10-29 14:57:51
* @Entity cn.jiyun.pojo.Role
*/
public interface RoleMapper extends BaseMapper<Role> {

    List<Role> findPage(Page<Role> page, Role role);

    @Select("select r.name,r.ms,r.state,group_concat(u.name) chengyuan,r.time from role r left join user u on r.id=u.yid where r.id=#{id}")
    Role chakan(Integer id);
}




